package com.service.pjsh;

import java.util.Vector;

import com.bpms.common.CommonUtil;
import com.bpms.common.JdbcWorker;
import com.bpms.common.VO;
import com.bpms.common.VOL;
import com.bpms.common.VOList;
import com.bpms.esb.IService;

public class Getcmdjb implements IService {

	public VO exec(VO arg0) {
		VO vo=new VO();
		JdbcWorker j=null;
		try{
			j=new JdbcWorker();
			
			String sign=arg0.getAttr("sign");
			StringBuffer sql=new StringBuffer("select * from CM_DJB WHERE SIGN='").append(sign).append("'");
			vo=j.readInCombination(new VO(), sql.toString());
			
			vo.setAttr("result", "0000");
			vo.setAttr("msg", "Getcmdjb成功");
			
		}catch (Exception e) {
			CommonUtil.debug("Getcmdjb exception", e);
			
			vo.setAttr("result", "9999");
			vo.setAttr("msg", "访问数据库失败");
		}
		
		return vo;
	}

}
